USE mseauth;

CREATE TABLE `realmcharacters` (
  `RealmId` int(10) unsigned NOT NULL DEFAULT '0',
  `AccountId` int(10) unsigned NOT NULL,
  `NumChars` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`RealmId`,`AccountId`),
  KEY `AccountId` (`AccountId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Realm Character Tracker';


